<?php
$sql = "alter table zh_article change cid `cid` int(10) unsigned NOT NULL default '0'";
$sql = "DROP TABLE IF EXISTS {{user_invite}}";
$sql ="
CREATE TABLE tt_user_invite (
  `vid` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `touid` int(10) unsigned NOT NULL default '0',
  `code` varchar(32) NOT NULL COMMENT '注册码',
  `expire` int(10) unsigned NOT NULL default '0' COMMENT '注册码有效期',
  `activetime` int(10) unsigned NOT NULL default '0' COMMENT '激活时间',
  `regtime` int(10) unsigned NOT NULL default '0' COMMENT '注册使用时间',
  `status` tinyint(1) unsigned NOT NULL default '0' COMMENT '0可用,1注册未激活,2.注册已激活',
  PRIMARY KEY  (`vid`),
  KEY `uid` (`uid`),
  KEY `touid` (`touid`),
  KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8";

//2012.05.12
alter table `wm_comment` add `stars` tinyint(1) unsigned NOT NULL default '0'

alter table `wm_orders_product` change comment `comment` tinyint(1) unsigned NOT NULL default '0'